<%@page import="com.immiinfo.model.immiCountry"%>
<%@page import="com.immiinfo.model.others"%>
<%@page import="com.immiinfo.model.Mymajor"%>
<%@page import="com.immiinfo.model.tiWorkExper"%>
<%@page import="com.immiinfo.model.workExper"%>
<%@page import="sun.security.krb5.internal.EncAPRepPart"%>
<%@page import="com.immiinfo.model.engCap"%>
<%@page import="com.DB.DBSelectHelper"%>
<%@page import="java.sql.Date"%>
<%@page import="com.DB.DBHelper"%>

<%@page import="com.immiinfo.model.baseInfo"%>
<%@ page contentType="text/html; charset=UTF-8" %>
<%@ page language="java" import="java.util.*"%>
<%@ page import="java.io.InputStreamReader"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在线评估系统</title>
<link rel="stylesheet" type="text/css" href="/immigration/css/guide.css" />
<link rel="stylesheet" type="text/css" href="/immigration/css/layout.css">
<script type="text/javascript" src="/immigration/js/jquery.js"></script>
<script type="text/javascript" src="/immigration/js/guide.js"></script>
<script type="text/javascript" src="../../js/score_selection.js"></script>
 <script type="text/javascript" src="../../js/laydate/laydate.js" > </script>
 <script type="text/javascript" src="../../js/Isselected.js"></script>
 <script type="text/javascript" src="../../js/table_manage.js"></script>

 <style type="text/css"> 
 .input1{vertical-align:text-bottom;margin-bottom:1px;*margin-bottom:0px;} 
 .radioType {
vertical-align:text-bottom;margin-bottom:-1px;*margin-bottom:-4px;
}
    body {
	margin: 0px;
	padding: 0px;
	font-size: 13px;
	border-top-style: hidden;
    }    
	
	#left{
		margin-left: 28px;
		}
	#left1{
		margin-left:45px;
		
		}
.main-connent,.right {
	margin-top: 60px;
}

.content {
	padding: 5px 50px;
	overflow: auto;
}

.main-connent {
	width: 75%;
	float: left;
	font-size: 13px;
	line-height: 14px;
	border-radius: 4px;
	box-shadow: 0 0 10px #ccc;
}

.right {
	width: 23%;
	float: right;
	font-size: 13px;
	line-height: 13px;
	border-radius: 4px;
	box-shadow: 0 0 10px #ccc;
}

.main-connent .main-left {
	width: 76%;
	float: left;
}

.main-connent .main-mid {
	width: 23%;
	float: right;
}

.main-connent .main-left .main-left-top {
	width: 100%;
}

.main-connent .main-left .main-left-bottom {
	width: 100%;
}

.main-left-bottom.main-bottom-left {
	width: 30%;
	float: left;
}

.main-left-bottom.main-bottom-right {
	width: 30%;
	float: right;
}

.main-connent .main-mid  .main-mid-top {
	width: 100%
}

.main-connent .main-mid  .main-mid-bottom {
	width: 100%
}

.title-icon {
	padding: 5px 15px;
	border-bottom: #fff 1px solid;
	color: #000000;
	font-weight: bold;
	font-size: 14px;
}

p {
	display: block;
	-webkit-margin-before: 0px;
	-webkit-margin-after: 0px;
	-webkit-margin-start: 0px;
	-webkit-margin-end: 0px;
	padding: 0 20px;
}

</style> 
</head>

<body>
	<div>
	<jsp:include page="/page/client/client_top.jsp"></jsp:include>
	</div>

	<div id="mainContent">
<%
	//设置请求的字符编码以支持中文
	request.setCharacterEncoding ("utf-8");

	int intPageSize; //一页显示的记录数 
	int intRowCount; //记录总数 
	int intPageCount; //总页数 
	int intPage; //待显示页码 
	String strPage; 
	
	//设置一页显示的记录数 
	intPageSize = 24; 
	
	//取得待显示页码 
	strPage = request.getParameter("page"); 
	if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 
		intPage = 1; 
	}
	else{//将字符串转换成整型 
		intPage = java.lang.Integer.parseInt(strPage); 
		if(intPage< 1){ 
			intPage = 1; 
		} 
	} 
	//获取请求参数
	
	//从web.xml获取全局参数
	String drv=config.getServletContext().getInitParameter("DBDriver");
	String url=config.getServletContext().getInitParameter("DBURL");
	String uid=config.getServletContext().getInitParameter("DBUser");
	String pwd=config.getServletContext().getInitParameter("DBPass");
	
	//构建SQL字符串和JDBC对象
	String strSQL1 = "SELECT * FROM immie0_immi.leftguide lg WHERE lg.father_id=-1";	// (id, name, content_name, content, url, father_id, date)
	String strSQL2 = "SELECT * FROM immie0_immi.leftguide lg WHERE lg.father_id=?";		// (id, name, content_name, content, url, father_id, date) 
	String strSQL3 = "SELECT * FROM immie0_immi.leftguide lg WHERE lg.father_id=?";   	// (id, name, content_name, content, url, father_id, date)
	String strSQL4 = "SELECT * FROM immie0_immi.rightguide rg WHERE rg.father_id=-1";	// (id, name, content_name, content, url, father_id, date)
	
	Connection conn = null;
	PreparedStatement pstmt1 = null;	
	PreparedStatement pstmt2 = null;
	PreparedStatement pstmt3 = null;
	PreparedStatement pstmt4 = null;
	
	ResultSet rs1 = null; //左侧导航父节点
	ResultSet rs2 = null; //左侧导航子节点
	ResultSet rs3 = null; //左侧导航子子节点
	ResultSet rs4 = null; //右侧导航
	
%>	
		<div id="sidebar">
			<div class="pnav-cnt">
<%
		try {
			Class.forName(drv).newInstance();
			conn = DriverManager.getConnection(url,uid,pwd);
			pstmt1 = conn.prepareStatement(strSQL1);		
			
			rs1 = pstmt1.executeQuery();
			
			while(rs1.next()) {
%>
				<div class="pnav-box" id="letter-a">
					<div class="box-title">
						<a class="btn-fold hidden" href="#"></a> 
						<a class="btn-unfold" href="#"></a> 
<% 						if( !rs1.getString(4).isEmpty() && rs1.getString(5).equals("NULL")){ //content非空， url=NULL，内部页面	
%>						<a href="/immigration/page/client/client_leftguide_display.jsp?CId=<%=rs1.getString(1)%>"><span class="pnav-letter" ><%=rs1.getString(2)%></span></a>
<%						}
						if( rs1.getString(4).equals("NULL") && !rs1.getString(5).isEmpty() ){ //content=NULL， url非空，外部链接	
%>						<a href="<%=rs1.getString(5)%>" target="_blank" ><span class="pnav-letter"><%=rs1.getString(2)%></span></a>
<%						}
%>					</div>
					
	<%			pstmt2 = conn.prepareStatement(strSQL2);
				//设置SQL语句参数
				pstmt2.setString(1, rs1.getString(1) );
						
				rs2 = pstmt2.executeQuery();
							
				if(rs2.next()) {			%>
								
					<ul class="box-list">
						<li>
							<a class="btn-fold hidden" href="#"></a> 
							<a class="btn-unfold" href="#"></a>
<% 							if( !rs2.getString(4).isEmpty() && rs2.getString(5).equals("NULL")){ //content非空， url=NULL，内部页面	
%>							<b> <a href="/immigration/page/client/client_leftguide_display.jsp?CId=<%=rs2.getString(1)%>" ><%=rs2.getString(2) %></a></b>
<%							}
							if( rs2.getString(4).equals("NULL") && !rs2.getString(5).isEmpty() ){ //content=NULL， url非空，外部链接	
%>							<b> <a href="<%=rs2.getString(5)%>" target="_blank" ><%=rs2.getString(2) %></a></b>
<%							}
%>							<span class="cDGray"> </span>	
<%					pstmt3 = conn.prepareStatement(strSQL3);
					//设置SQL语句参数
					pstmt3.setString(1, rs2.getString(1) );
								
					rs3 = pstmt3.executeQuery();
									
					while(rs3.next()) { 		%>
							<p style="margin:0 0 0 0;">
<% 							if( !rs3.getString(4).isEmpty() && rs3.getString(5).equals("NULL")){ //content非空， url=NULL，内部页面	
%>								<a href="/immigration/page/client/client_leftguide_display.jsp?CId=<%=rs3.getString(1)%>" ><%=rs3.getString(2)%></a>
<%							}
							if( rs3.getString(4).equals("NULL") && !rs3.getString(5).isEmpty() ){ //content=NULL， url非空，外部链接	
%>								<a href="<%=rs3.getString(5)%>" target="_blank" ><%=rs3.getString(2) %></a>
<%							}
%>							</p>
<% 					}	//第三个while 结束			%>
						</li>
<% 				}
							
				while(rs2.next()) { 		%>
						<li><a class="btn-fold hidden" href="#"></a> 
							<a class="btn-unfold" href="#"></a>
<% 							if( !rs2.getString(4).isEmpty() && rs2.getString(5).equals("NULL")){ //content非空， url=NULL，内部页面	
%>							<b> <a href="/immigration/page/client/client_leftguide_display.jsp?CId=<%=rs2.getString(1)%>" ><%=rs2.getString(2) %></a></b>
<%							}
							if( rs2.getString(4).equals("NULL") && !rs2.getString(5).isEmpty() ){ //content=NULL， url非空，外部链接	
%>							<b> <a href="<%=rs2.getString(5)%>" target="_blank" ><%=rs2.getString(2) %></a></b>
<%							}
%>							<span class="cDGray"> </span>											
<%					pstmt3 = conn.prepareStatement(strSQL3);
					//设置SQL语句参数
					pstmt3.setString(1, rs2.getString(1) );
							
					rs3 = pstmt3.executeQuery();
							
					while(rs3.next()) { 		%>
							<p style="margin:0 0 0 0;">
<% 							if( !rs3.getString(4).isEmpty() && rs3.getString(5).equals("NULL")){ //content非空， url=NULL，内部页面	
%>								<a href="/immigration/page/client/client_leftguide_display.jsp?CId=<%=rs3.getString(1)%>" ><%=rs3.getString(2)%></a>
<%							}
							if( rs3.getString(4).equals("NULL") && !rs3.getString(5).isEmpty() ){ //content=NULL， url非空，外部链接	
%>								<a href="<%=rs3.getString(5)%>" target="_blank" ><%=rs3.getString(2) %></a>
<%							}
%>							</p>
	<% 				}	//第三个while 结束			%>
						</li>
	<%			}//第二个while 结束					%>
					</ul>
				</div>
<% 			}	//第一个while 结束					%>
			<script type="text/javascript">
				//<![CDATA[ 
					(function() {
						NTES("span.photo-search input[type=text]")
							.addEvent(
								"focus",
								function() {
									this.value == this.defaultValue
											&& (this.value = "");
								})
							.addEvent(
								"blur",
								function() {
									this.value == ""
											&& (this.value = this.defaultValue);
								});
						NTES("div.pnav-box div.box-title a.btn-fold")
							.addEvent(
								"click",
								function(e) {
									e.preventDefault();
									var eleTitle = NTES(this.parentNode);
									NTES(this).addCss("hidden");
									eleTitle.$("a.btn-unfold")
											.removeCss("hidden");
									NTES(eleTitle.parentNode).$(
											"ul.box-list")
											.removeCss("hidden");
								});
						NTES("div.pnav-box div.box-title a.btn-unfold")
							.addEvent(
								"click",
								function(e) {
									e.preventDefault();
									var eleTitle = NTES(this.parentNode);
									NTES(this).addCss("hidden");
									eleTitle.$("a.btn-fold")
											.removeCss("hidden");
									NTES(eleTitle.parentNode).$(
											"ul.box-list").addCss(
											"hidden");
								});
						NTES("div.pnav-box ul.box-list a.btn-fold")
							.addEvent(
								"click",
								function(e) {
									e.preventDefault();
									var eleTitle = NTES(this.parentNode);
									NTES(this).addCss("hidden");
									eleTitle.$("a.btn-unfold")
											.removeCss("hidden");
									eleTitle.$("p").removeCss(
											"hidden");
								});
						NTES("div.pnav-box ul.box-list a.btn-unfold")
							.addEvent(
								"click",
								function(e) {
									e.preventDefault();
									var eleTitle = NTES(this.parentNode);
									NTES(this).addCss("hidden");
									eleTitle.$("a.btn-fold")
											.removeCss("hidden");
									eleTitle.$("p")
											.addCss("hidden");
								});
						new NTES.ui.Slide(NTES("ul.photo-snav li"),
								NTES("div.photo-scnt"), "active",
								"mouseover", 6000);
					})();
					//]]>
				</script>
			</div>
		</div>				
		<div id="evaluation_testdisplay" style=" min-height:856px; border-left:#dcdddd 1px solid; border-top:#dcdddd 1px solid; border-right:#dcdddd 1px solid; margin:0 0 0 187px !important; background-image: url(/immigration/image/client_bg.png);" >

				<form  name="add" method="post" action="addEvalutionInfo" onsubmit="return checkISNull()">
				      <table width="900" border="0"  cellspacing="0"  align="center">
				        <tr>
				          <td colspan="4"></td>
				        </tr>
				        <tr>
				          <td colspan="4" style="font-size:14px; font-weight:bold" align="center" height="50px" ><p></p><p></p><p>技术移民在线评估</p></td>
				        </tr>
				       
				     
				        <tr >
				          <td height="35" colspan="4" ><div><b>一、基本信息<font size="" color="#FF0000">*</font></b></div></td>
				        </tr>
				        <tr height="20px" >
				          <td width="127">
				            <p id="left">姓名</p>
				           </td>
				          <td width="250" ><div id="left" >
				          <input type="text" name="name" id="name" style="width:200;height:15px" /></div>
				          </td>
				          <td width="127" >
				          <p >性别</p>          
				          </td>
				          <td width="350" ><div style="margin-left:20px">
				          <select name="gender"  style="width:200;height:25px;font-size:12px;" >
				            <option style="font-size:13">男</option>
				            <option style="font-size:13">女</option>
				          </select></div>
				          </td>
				        </tr>
				        <tr >
				          <td  > <p id="left">居住城市</p>          </td>
				          <td  ><div id="left"><input type="text" style="width:200;height:15px" name="city"  /></div></td>
				          <td ><p >拟移民国家</p></td>
				          <td  ><div style="margin-left:20px"><select name="immicountry" style="width:200;height:25px;font-size:12px">
				           <%				                    
				                  List<immiCountry> immicountry=DBHelper.getCountry();
				                     for(int i=0;i<immicountry.size();i++)
				                     {
				                    	 %>
				                    	 <option  value=<%=immicountry.get(i).getCountry()%>><%=immicountry.get(i).getCountry()%></option>
				                    <%} %>
				        <!--  <option>澳大利亚</option> -->
				          </select></div></td>
				        </tr>
				        <tr  >
				          <td ><p id="left"> E-mail</p></td>
				          <td ><div id="left"><input type="text" style="width:200;height:15px" name="email" /></div></td>
				          <td ><p >电话号码</p>          </td>
				          <td><div style="margin-left:20px"><input type="text" name="phonenumber" style="width:200;height:15px" /></div></td>
				        </tr>
				        <tr >
				          <td ><p id="left">QQ号</p></td>
				          <td><div id="left"><input name="QQ" type="text"   style="width:200;height:15px"/> </div></td>
				          <td><p >微信</p></td>
				          <td><div style="margin-left:20px"><input type="text" name="weixin" style="width:200;height:15px" /></div></td>
				        </tr>
				        <tr>   <td colspan="4"><HR style="margin-top:0px;" width="100%" color='#CCCCCC' SIZE=0.1/><b >二、年龄<font size="" color="#FF0000">*</font></b><p id="left" style="margin-top:8px;">请选择出生日期&nbsp;<input name="birthday1" type="text" onclick="laydate()"   style="width:200;height:15px"/></p></td><tr>
				      <tr>   <td colspan="4"><HR style="margin-top:0px;" width="100%" color='#CCCCCC' SIZE=0.1/><b >三、英语能力<font size="" color="#FF0000">*</font></b></td><tr>
				        <tr>
				          <td colspan="4"><p id="left" style="margin-top:10px" >是否通过英语考试  &nbsp;&nbsp;<input name="passExam" type="radio" value="1" id="eng_text_yes" onclick="ischecked1()" style="margin-top:-4px"/>&nbsp;是&nbsp;&nbsp;     
				          &nbsp;&nbsp;<input name="passExam" type="radio" value="0" id="eng_text_no" onclick="ischecked1()" style="margin-top:-4px"/>&nbsp;否
				          </p>
				            <p id="left">请选择
				                <select name="english_text_type"  style="width:200;height:25px;font-size:12px"  name="english_text_type" id="english_text_type" onchange="setScore(this)"  >
				                    <option >考试类别</option> 
				                    <option>雅思A（IELTS）</option>
				                    <option>雅思G（IELTS）</option>
				                     <option>职业英语考试（OET）</option>
				                      <option>托福（TOEFL）</option>
				                       <option>学术英语考试（PTE）</option>
				                        <option>剑轿英语等级证书考试（CAE）</option>
				                 <%--  <%
				                    
				                  List<String> engCapList=DBSelectHelper.getAllProblemAnswer("英语能力");
				                     for(int i=0;i<engCapList.size();i++)
				                     {
				                    	 %>
				                    	 <option value=<%=engCapList.get(i)%>><%=engCapList.get(i)%></option>
				                    <%} %> --%>
				                </select>
				            </p>
				            <p id="left" style="margin-top:-5px;">听力
				              <select name="listening" id="listening" style="width:150px;height:25px" >
				              </select>
				              口语
				              <select name="speaking" id="speaking" style="width:150px;height:25px" >
				              </select>
				              阅读
				              <select name="reading" id="reading" style="width:150px;height:25px" >
				              </select>
				              写作
				              <select name="writing" id="writing" style="width:150px;height:25px" >
				              </select>
				          </p></td>
				        </tr>
				        
				         <tr>
				          <td colspan="4"><HR style="margin-top:-8px;" width="100%" color='#CCCCCC' SIZE=0.1/>
				            <div ><b>四、工作经历</b><font color="#FF0000">*</font>
				              <p id="left" style="margin-top:10px">过去十年是具否有工作经历
				                &nbsp;&nbsp;<input name="offjob" type="radio" value="1" id="workinaus_yes" onclick="iswork1()"  style="margin-top:-4px"/>&nbsp;是&nbsp;&nbsp;
				                &nbsp;&nbsp;<input name="offjob" type="radio" id="workinaus_no" value="0" onclick="iswork1()"  style="margin-top:-4px"/>&nbsp;否&nbsp;&nbsp;</p>
				   <div style="margin-left:48px;margin-top:10px">
				<table width="800" border="0" cellspacing="0" cellpadding="0" id="work_experiencetable">
				  <tr>
				    <td width="185" height="30" align="center" bgcolor="#CCCCCC">职业名称</td>
				    <td width="185" align="center" bgcolor="#CCCCCC">受雇国家</td>
				    <td width="185" align="center" bgcolor="#CCCCCC">起始时间</td>
				    <td width="185" align="center" bgcolor="#CCCCCC">结束时间</td>
				    <td width="60" align="center" bgcolor="#CCCCCC">删除</td>
				    
				  </tr>
				  <tr>
				    <td  align="left"><div style="margin-top:8px"><input type="text" name="job1" id="job1"style="width:91%;height:15px;" /></div></td>
				    <td align="center"><div style="margin-top:8px"><input type="text" style="width:90%;height:15px;"  name="country1"  id="country1" /></div></td>
				    <td align="center"><div style="margin-top:8px"><input type="text" style="width:90%;height:15px;"  name="work_starttime1" id="work_starttime1" onclick="laydate()" /></div></td>
				    <td align="center"><div style="margin-top:8px"><input type="text" style="width:90%;height:15px;"  name="work_endtime1" id="work_endtime1" onclick="laydate()" /></div></td>
				    <td align="center"><p style="margin-top:8px"><input type="button"  value="删除" style="background-color:#FFF;margin-top:0" onclick="deleteCurrentRow(this)"></p></td>
				  </tr>
				</table><input type="button"  value="添加" id="IaddTR" onclick="addtr()" style="background-color:#FFF" />
				</div>
				<!--</form>--><p></p>
				<p id="left" >过去十年是否具有与提名职业相关的工作经历&nbsp;&nbsp;
				            <input name="ishasTiWorkEx" type="radio" value="1" id="workinaus_yes3"  style="margin-top:-4px"/>
				&nbsp;是&nbsp;&nbsp;&nbsp;&nbsp;
				<input name="ishasTiWorkEx" type="radio"  value="0"   style="margin-top:-4px"/>
				&nbsp;否            </p>
				            </div>
				            <div >
				              <div >
				                <p class="text" id="left" style="margin-top:-5px;">1、与提名职业相关的澳大利亚境外工作经历&nbsp;&nbsp;<select name="out_aus_work" id="out_aus_work" style="height:25px;font-size:12px">
				                  <option>在澳大利亚以外国家受雇佣不足三年</option>
				                  <option>在澳大利亚以外国家已经受雇佣三年</option>
				                  <option>在澳大利亚以外国家已经受雇佣五年</option>
				                  <option>在澳大利亚以外国家已经受雇佣八年</option>
				                  <%-- <%
				                     List<String> out_ausList=DBSelectHelper.getAllProblemAnswer("1、与提名职业相关的澳大利亚境外工作经历");
				                     for(int i=0;i<out_ausList.size();i++)
				                     {
				                    	 %>
				                    	 <option value=<%=out_ausList.get(i)%>><%=out_ausList.get(i)%></option>
				                    <%} %> --%>
				                  </select>
				                </p>
				                <p class="text" id="left" style="margin-top:-10px;"> 2、与提名职业相关的澳大利亚境内工作经历&nbsp;&nbsp;<select name="in_aus_work" id="in_aus_work" style="height:25px;font-size:12px">
				                 <option>在澳大利亚受雇佣不足一年</option>
				                  <option>在澳大利亚已经受雇佣一年</option>
				                  <option>在澳大利亚已经受雇佣三年</option>
				                  <option>在澳大利亚已经受雇佣三年</option>
				                  <option>在澳大利亚已经受雇佣八年</option>
				                  
				                <%--   <%
				                     List<String> in_ausList=DBSelectHelper.getAllProblemAnswer("2、 与提名职业相关的澳大利亚境内工作经历");
				                     for(int i=0;i<in_ausList.size();i++)
				                     {
				                    	 %>
				                    	 <option value=<%=in_ausList.get(i)%>><%=in_ausList.get(i)%></option>
				                    <%} %> --%>
				                </select>
				                </p>
				              </div>
				              <div>
				               
				              </div>
				            </div></td>
				        </tr>  
				       <tr>
				          <td colspan="4"><HR style="margin-top:-8px;" width="100%" color='#CCCCCC' SIZE=0.1/><div style="margin-top:0px" ><b >五、学历</b>
				            <font size="" color="#FF0000">*</font></div>
				            <div style="margin-top:-2px">
				              <div class="text" id="left1"style="margin-top:0px" ><br/>
				                <table width="800"   border="0" cellpadding="0" cellspacing="0" id="Iqualification">
				                  <tr align="center" bgcolor="#CCCCCC" height="30px">
				                    <td width="150">学历</td>
				                    <td width="150">专业名称</td>
				                    <td width="150">获得国家</td>
				                    <td width="150">开始时间</td>
				                    <td width="150">结束时间</td>
				                  </tr>
				                  <tr align="center">
				                    <td><div style="margin-top:8px;" align="left">
				                    <select name="eduLevel" style="width:99%;height:25px;font-size:13px">
				                    
				                    <option>没有被承认的学历</option>
				                      <option>专科或其他文凭</option>
				                        <option>本科学位</option>
				                        <option>硕士学位</option>
				                         <option>博士学位</option>
				                    </select></div></td>
				                    <td><div style="margin-top:8px"><input type="text" name="major1" style="width:90%;height:15px;" /></div></td>
				                    <td><div style="margin-top:8px"><input type="text" name="majorCountry"  style="width:90%;height:15px;" /></div></td>
				                    <td><div style="margin-top:8px"><input name="begintime1" type="text"    style="width:90%;height:15px;" onclick="laydate()"/></div></td>
				                    <td><div style="margin-top:8px"><input name="endtime1" type="text"   style="width:90%;height:15px;" onclick="laydate()"/></div></td>
				                  </tr>
				                </table><input type="button"  value="添加"  onclick="addbachelor()" style="background-color:#FFF" />（注：如果最高学历为本科以上，请务必填写本科学历情况！）
				           
				              </div>
				            </div></td>
				        </tr>
				          <tr>
				          <td colspan="4"><HR style="margin-top:10px;" width="100%" color='#CCCCCC' SIZE=0.1/><div ><b>六、其它</b>
				          </div>
				            <div >
				              <div class="text" id="left" style="margin-top:10px">
				              <p></p>
				              
				                   <%
				                     List<String> otherList=DBSelectHelper.getAllProblemAnswer("其它");
				                     for(int i=0;i<otherList.size();i++)
				                     {
				                    	 %>
				                    	 <p ><input type="checkbox"  style="margin-top:-4px" name="other" value=<%=otherList.get(i)%>>&nbsp;&nbsp;<%= otherList.get(i)%></p>
				                    <%} %>
				              </div>
				            </div></td>
				            </tr>
				         <tr>
				          <td colspan="4"><HR style="margin-top:0px;" width="100%" color='#CCCCCC' SIZE=0.1/><div >
				            <div style="margin-left:0" >
				            
				              <b>七、配偶</b>
				              
				            </div>
				            <div >
				              <p class="text" id="left" style="margin-top:10px">
				               婚姻状况<font size="" color="#FF0000">*</font>&nbsp;&nbsp;
				                  <input type="radio"  style="margin-top:-4px" name="isMarry" id="marriage_y" value="1" onclick="ismarried()" />&nbsp;已婚&nbsp;&nbsp;&nbsp;&nbsp;
				                  <input type="radio" style="margin-top:-4px""  name="isMarry" id="marriage_n" value="0" onclick="ismarried()"/> &nbsp;未婚              
				              </p>
				            </div>
				          </div></td>
				        </tr>
				        <tr id=“tr1” >
				          <td colspan="4"><p id="left"><b>1、配偶年龄</b></p></td>
				        </tr>
				        <tr id="tr2" height="20px" >
				          <td colspan="4"><p id="left" style="margin-top:-5px">请选择出生日期
				            <input name="Partnerbirthday" style="width:200px;height:15px" type="text" onclick="laydate()"  id="birthday2" />
				           </p></td>
				        </tr>
				        
				        <tr id="tr4" >
				          <td colspan="4" ><p id="left" style="margin-top:-8px;"><b>2、配偶英语能力</b></p><p id="left" style="margin-top:8px">是否通过英语考试&nbsp;&nbsp;
				            <input name="isPartenrPass" type="radio" value="1" id="eng_text_yes2" onclick="ischecked2()"  style="margin-top:-4px"/>
				          &nbsp;是&nbsp;&nbsp;&nbsp;&nbsp;
				            <input name="isPartenrPass" type="radio" value="0" id="eng_text_no2" onclick="ischecked2()"  style="margin-top:-4px"/>
				       &nbsp;否 </p>
				            <p id="left">请选择
				              <select name="english_text_type2"  style="width:200px;height:25px;font-size:13px" id="english_text_type2" onchange="setScore2(this)">				              
				                <option >考试类别</option> 
				                    <option>雅思A（IELTS）</option>
				                    <option>雅思G（IELTS）</option>
				                     <option>职业英语考试（OET）</option>
				                      <option>托福（TOEFL）</option>
				                       <option>学术英语考试（PTE）</option>
				                        <option>剑轿英语等级证书考试（CAE）</option>
				                 <%--  <%
				                     for(int i=0;i<engCapList.size();i++)
				                     {
				                    	 %>
				                    	 <option value=<%=engCapList.get(i)%>><%=engCapList.get(i)%></option>
				                    <%} %> --%>
				              </select>
				            </p>
				            <p id="left">听力
				              <select name="listening2" id="listening2" style="width:150px;height:25px">
				              </select>
				              口语
				              <select name="speaking2" id="speaking2" style="width:150px;height:25px">
				              </select>
				              阅读
				              <select name="reading2" id="reading2" style="width:150px;height:25px">
				              </select>
				              写作
				              <select name="writing2" id="writing2" style="width:150px;height:25px">
				              </select>
				            </p></td>
				        </tr>
				         <tr id="tr5" >
				          <td colspan="4"><div id="left">
				            <p style="margin-top:-8px;"><b>3、配偶工作经验</b> </p>
				            <div >
				              <p style="margin-top:0px;">配偶过去十年是具否有工作经历&nbsp;&nbsp;
				                <input  style="margin-top:-4px" name="paroffjob" type="radio" value="1" id="workinaus_yes2" onclick="iswork2()"/>&nbsp;是&nbsp;&nbsp;&nbsp;&nbsp;
				                <input  style="margin-top:-4px" name="paroffjob" type="radio" id="workinaus_no3" value="0" onclick="iswork2()" />&nbsp;否</p>
	
				        <div style="margin-left:20px">   <table width="800" border="0" cellspacing="0" cellpadding="0" id="par_work_experiencetable" >
				  <tr>
				    <td width="185" height="30" align="center" bgcolor="#CCCCCC">职业名称</td>
				    <td width="185" align="center" bgcolor="#CCCCCC">受雇国家</td>
				
				    <td width="185" align="center" bgcolor="#CCCCCC">起始时间</td>
				    <td width="185" align="center" bgcolor="#CCCCCC">结束时间</td>
				    <td width="60" align="center" bgcolor="#CCCCCC">删除</td>
				    
				  </tr>
				  <tr>
				    <td  align="left"><div style="margin-top:8px"><input type="text" name="par_job1" id="par_job1" style="width:91%;height:15px;"/></div></td>
				    <td align="center"><div style="margin-top:8px"><input name="par_country1" id="par_country1" type="text"  style="width:90%;height:15px;"/></div></td>
				    <td align="center"><div style="margin-top:8px"><input type="text"  name="par_work_starttime1" style="width:90%;height:15px;" id="par_work_starttime1" onclick="laydate()" /></div></td>
				    <td align="center"><div style="margin-top:8px"><input type="text"  name="par_work_endtime1" style="width:90%;height:15px;" id="par_work_endtime1" onclick="laydate()" /></div></td>
				    <td align="center"><p style="margin-top:8px"><input  type="button" value="删除" size="1" style="background-color:#FFF"  onclick="deleteCurrentRow(this)"></p></td>
				  </tr>
				</table><input type="button"  value="添加" id="paraddTR"  onclick="par_add()" style="background-color:#FFF" /><!-- </form> -->
				    </div> <p ></p>  <p>配偶过去两年内是否具有至少一年与提名职业相关的工作经历&nbsp;&nbsp;
				                <input name="ParishasTiWorkEx" type="radio" value="1" id="workinaus_yes4"  style="margin-top:-4px"/>
				              &nbsp;是&nbsp;&nbsp;&nbsp;&nbsp;
				                <input name="ParishasTiWorkEx" type="radio" id="workinaus_no4" value="0"   style="margin-top:-4px"/>
				              &nbsp;否 &nbsp;&nbsp;</p>
				            </div>
				            <div >
				              <div >
				                <p class="text" id="left2" style="margin-top:-5px;">①配偶过去十年与提名职业相关的澳大利亚境外工作经历&nbsp;&nbsp;<select name="par_out_aus_work" id="out_aus_work2"  style="width:250px;height:25px;font-size:12px">
				                   <option>在澳大利亚以外国家受雇佣不足三年</option>
				                  <option>在澳大利亚以外国家已经受雇佣三年</option>
				                  <option>在澳大利亚以外国家已经受雇佣五年</option>
				                  <option>在澳大利亚以外国家已经受雇佣八年</option> 
				                    <%--  <%
				                     for(int i=0;i<out_ausList.size();i++)
				                     {
				                    	 %>
				                    	 <option value=<%=out_ausList.get(i)%>><%=out_ausList.get(i)%></option>
				                    <%} %> --%>
				                  </select>
				                </p>
				                <p class="text" style="margin-top:-10px;"> ②配偶过去十年与提名职业相关的澳大利亚境内工作经历&nbsp;&nbsp;<select name="par_in_aus_work" id="in_aus_work2" style="width:250px;height:25px;font-size:12px">
				                      <option>在澳大利亚受雇佣不足一年</option>
				                  <option>在澳大利亚已经受雇佣一年</option>
				                  <option>在澳大利亚已经受雇佣三年</option>
				                  <option>在澳大利亚已经受雇佣三年</option>
				                  <option>在澳大利亚已经受雇佣八年</option>
				                 <%--     <%
				                     for(int i=0;i<in_ausList.size();i++)
				                     {
				                    	 %>
				                    	 <option value=<%=in_ausList.get(i)%>><%=in_ausList.get(i)%></option>
				                    <%} %> --%>
				                  </select>
				                </p>
				              </div>
				            </div>
				          </div>
				          <div >
				            <div>
				              <div class="text" id="left"></div>
				            </div>
				          </div></td>
				        </tr>
				         <tr id="tr6" >
				          <td colspan="4"><p id=left style="margin-top:-8px;"><b>4、配偶学历</b></p><div 
				            id="left">
				          </div>
				            <div style="margin-top:-15px">
				              <div  style="margin-left:48px;margin-top:-10px"><br/>
				               <table width="800"   border="0" cellpadding="0" cellspacing="0" id="parqualification">
				                  <tr align="center" bgcolor="#CCCCCC" height="30px">
				                    <td width="150">学历</td>
				                    <td width="150">专业名称</td>
				                    <td width="150">获得国家</td>
				                    <td width="150">开始时间</td>
				                    <td width="150">结束时间</td>
				                  </tr>
				                  <tr align="center">
				                    <td ><div style="margin-top:8px" align="left">
				                    <select name="PartnereduLevel" id="par_qua" style="width:99%;height:25px;font-size:13px">

				                    <option>没有被承认的学历</option>
				                      <option>专科或其他文凭</option>
				                        <option>本科学位</option>
				                        <option>硕士学位</option>
				                         <option>博士学位</option>
				                    </select></div></td>
				                    <td><div style="margin-top:8px"><input type="text" name="major2"id="major22" style="width:90%;height:15px;" /></div></td>
				                    <td><div style="margin-top:8px"><input type="text" name="majorcountry2" id="majorcountry22"  style="width:90%;height:15px;" /></div></td>
				                    <td><div style="margin-top:8px"><input name="begintime2" type="text" id="begintime22"  onclick="laydate()"  style="width:90%;height:15px;"/></div></td>
				                    <td><div style="margin-top:8px"><input name="endtime2" type="text" id="endtime22" onclick="laydate()"  style="width:90%;height:15px;"/></div></td>
				                  </tr>
				                </table><input type="button" id="addparbachelorID"  value="添加"  onclick="addparbachelor()" style="background-color:#FFF" />（注：如果最高学历为本科以上，请务必填写本科学历情况！）
				            
				           
				              </div>
				            </div>  <p id="left" style="margin-top:10px;margin-left:">（注： 本问卷将按照澳洲技术移民评分标准进行自动评分！）</p></td>
				        </tr>
				       
				  
				        <tr>
				          <td height="56" colspan="4" align="center" ><input  type="submit" name="submit" value="确认提交"  style="background-color:#FFF"  > 
				                        <input type="reset" name="reset" value="清空重填" onclick="location.reload()" style="background-color:#FFF">
				          </td>
				       </tr>
				      </table>
				  </form>

<%					} catch (ClassNotFoundException e) {
						e.printStackTrace();
					} catch (InstantiationException e) {
					    e.printStackTrace();
					} catch (IllegalAccessException e) {
						e.printStackTrace();
					} catch (SQLException e) {
						e.printStackTrace();
					} 
					finally {
						if (rs1 != null) {
							rs1.close();
							rs1 = null;
						}
						if (rs2 != null) {
							rs2.close();
							rs2 = null;
						}
						if (rs3 != null) {
							rs3.close();
							rs3 = null;
						}
						if (rs4 != null) {
							rs4.close();
							rs4 = null;
						}
						if (pstmt1 != null) {
							pstmt1.close();
							pstmt1 = null;
						}	
						if (pstmt2 != null) {
							pstmt2.close();
							pstmt2 = null;
						}
						if (pstmt3 != null) {
							pstmt3.close();
							pstmt3 = null;
						}
						if (pstmt4 != null) {
							pstmt4.close();
							pstmt4 = null;
						}
						if (conn != null) {
							conn.close();
							conn = null;
						}
					}
%>								

			</div>
			<br class="clearfloat" />
		</div>

	<div id="footer">
		<jsp:include page="/page/footer.jsp"></jsp:include>
	</div>
   
  </body>
</html>